By using joiner t/r we can join only 2 tables, SO if want
join more than 2 flat files ,How can i join?
Answer / rahul
for n source we required n-1 joiner t/r.
ex: if we have 3 flat file dan we requried 2 joiner t/r
| Is This Answer Correct ? | 16 Yes | 0 No |
what are the deliverables?in your project?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
what is target update override and when we use it?
Define maping and sessions?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
what transformations are used for Variable port?
How many repositories can be created in informatica?
While importing the relational source defintion from database,what are the meta data of source U import?
What is the benefit of partitioning a session?
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
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
What is batch and describe about types of batches?