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 |
How to load a Dimension ? and how to load a fact table?
what is worklet and what use of worklet and in which situation we can use it?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
how to load dimension table and fact table. plz tell me the steps.
As union transformation gives UNION ALL output, how you will get the UNION output?
what is plsql table?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
How do you load alternate records into different tables through mapping flow?
Informatica settings are available in which file?
what is the incremental agrrigation?
What is Datadriven?