What is the difference between a connected look up and unconnected lookup?
No Answer is Posted For this Question
Be the First to Post Answer
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
how to load duplicate row in a target
What is sorter transformation?
what happens if you try to create a shortcut to a non- shared folder?
What are the associated ports in look up T/R.
Write the prerequisite tasks to achieve the session partition?
What do you mean by filter transformation?
If we have lookup table in workflow how do you trouble shhot to increase performance?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Describe two levels in which update strategy transformation sets?