Hi Cognos,
Simple do this
Up Str tgt
------ -----
amt(I,O)---------> amt(I)
Lkp_Id(I,O)------> Id(I,PK)
in the above in place of Lkp_ID, put src_id.
Your Up Str contains 3 ports.
amt
Lkp_Id
Src_Id
Now Map like this
Up Str tgt
------ -----...
Hi, If you are working on Informatica 6.1 or 6.2, You must have a network to your PC. Network means, it may be having Internet connection (cable or dial up). Then your PC recognises ip address. Put this ip address at host ip address during server registration in workflow manager. Then press...
You have to place your flat file in some directory in the Informatica server and not on your PC Client. And put the proper path and file name at sources and targets. This solves your problem. If you have further questions, let me know.
Hi, The only reason I could see for this error is:
You might have mapped source id from Lookup port (this happend to be your target field) and not the one coming from source. So whenever your target source id is null, then you need to insert a row. It is inserting other data but source id. This...
My personnal experience is if you have good real time experience, it is worthy to think about it. Otherwise just ignore it. Since the examinations questions looks tricky, I advice a real time experience guys only to write. If you have, it is easy to write.
Perfect definition is:
Active Transformation: No.of rows takes as input should be equal to no.of rows goes out from it as output.
ex: Expression, stored procedure,...
Passive: MAY not equal to
ex: Filter, Router, Rank etc...
Hi
I would suggest to go for "pass through" partition and change sql query of each partition adding a condition in WHERE clause as
ex.
Account_key between 1 and 1000000 (for partition 1)
Account_key between 1000001 and 2000000 (for partition 2)
Account_key between 2000001 and 3000000...
Hi Narsimha, here it is
right click on Session name -> press 'Edit' -> in propertie tab 4th is Enable test load - tick it and - 5th is no.of rows to test - type as 1000. then press OK.
But wth this option you will not be able to check the data in the target table.
You can manually stop the...
Hi
You must configure your PC to use User name and password. And use the same username/password of your PC login during Informatica server installation.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.