Interested to Buy Any Domain ? << Click Here >> for more details...
how we load the data from source to staging area
- 4 Answers
- 8952 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / jz
one to one mapping and through Bulk Loading
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
Can you use flat files in Mapplets.
Which development components of informatica have the highest usage?
Differentiate between a database and data warehouse?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What differs when we choose the sorted input for aggregator transformation?
What are the uses of etl tools?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How does a sorter cache works?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to extract sap data using informatica? What is abap? What are idocs?
How we can create indexes after completing the loan process?
How to extract sap data using informatica?
