what is diffrence b/w joner and union transfermation
Answer Posted / chandrp
At the maximum a join trasformation can join only 2 tables.
but union transformation will join more than two tables at
a time.
Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can we use mapping variables in informatica? Where do we use them?
Define sessions in informatica etl?
What is a sorter transformation?
What do you mean by channel change?
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 joiner transformation?
What is an Integration service in Informatica?
What is a predefined event?
What the difference is between a database, a data warehouse and a data mart?
can we override a native sql query within informatica? Where do we do it?
Write the prerequisite tasks to achieve the session partition?
How to create the source and target database connections in server manager?
In how many ways we can create ports?