What are the join types in joiner transformation?
Answer / swetha
Normal (Default)
Master outer
Detail outer
Full outer
| Is This Answer Correct ? | 5 Yes | 0 No |
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
How will u pas the data with out debugger?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
how to join the 2 different table with different columns in informatica?
My source table having some records ,i want load 1st record and last record into one target?
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
What are the differences between source qualifier and joiner transformation?
What is target designer and target load order?
Under which circumstances, informatica server creates reject files?
What is the Difference between sorter and aggregator?
What is a predefined event?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....