From where you extract the data, how you did it into
informatica? explain....
Answer Posted / davankumar
Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
What is informatica metadata and where is it stored?
Performance tuning in UNIX for informatica mappings?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
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
Define update strategy?
What are data-driven sessions?
What is the Process to creating lookup transformation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Please let me know how to make encryption and decryption with example?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is an active transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the features of complex mapping?
what is song in infrmatica...?