i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
Answer Posted / bsgsr
after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the function of look up transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
have u done any performance tuning? how u ll do?
Why do you use Mapping Parameter and mapping variable?
What is session task and command task?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How might one distinguish in the case of mapping is right or not without associating session?
What is a standalone command task?
What is dimensional table? Explain the different dimensions.
What is the difference between STOP and ABORT options in Workflow Monitor?
Why filter transformation is an active one?
What is resilience time?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?