Answer Posted / ravikumar
Hi,
You can Say LookUp is a Left Outer join.Your Source Table is
Left side table and Lookup table is right table.
Now you are trying to get total source records and
matching records from lookup table(right table).
Hope this helpls....
ravikumar.pasupula@outlook.com
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Can there be sub steps of etl steps?
Do we need an etl tool?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What do you understand by the term ‘transformation’?
Is hadoop a etl tool?
What is the difference between project backlog and product backlog?
Can u access a repository created in previous version of Informatica?
What is initial load and what is full load?
how do u set partition points in the mapping?
Compare ETL & Manual development?
what is the meaning of upgradation of Repository?
how to connect to a flatfile through ftp in informatica
Explain different types of partitioning?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
