how we load the data from source to staging area
- 4 Answers
- 8059 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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the types of presistent cache in look up tr.
What is the meaning of decode in informatica?
What is union transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Partition, what happens if the specified key range is shorter and longer
Briefly define a session task?
What do you mean by filter transformation?
What is mapping debugger?
How to convert multiple rows to single row (multiple columns) in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the command used to run a batch?
Under what condition selecting sorted input in aggregator may fail the session?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
