How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / shalijni
There are 6 kinds of transformation(3 pairs of discretion)::
Active and Passive
Connected and Unconnected
Cache and Non Cache creating(Sorry the exact name escapes
me at the moment)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
How can we use batches?
How to do unit testing in informatica? How to load data in informatica ?
where to store informatica rejected data? How to extract the informatica rejected data?
What does update strategy mean, and what are the different option of it?
What are the tasks that source qualifier perform?
How would you join a node to the already existing domain?
What is the use of code page?
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
Explain what is informatica metadata and where is it stored?
How to use procedural logic inside infromatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the scenario which compels informatica server to reject files?
What is meant by target load plan?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?