Interested to Buy Any Domain ? << Click Here >> for more details...
There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
- 9 Answers
- 14509 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi
not folder.we have mention folder fath
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Where is metadata stored?
What is the difference between a repository server and a powerhouse?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
how to load dimension table and fact table. plz tell me the steps.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to create a non-reusable instance of reusable transformations?
How might one distinguish in the case of mapping is right or not without associating session?
During the running session, output files are created by informatica server. Enlist few of them.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is data transformation manager process?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the fact table?
What is the different lookup cache(s)?
