HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?

Answer Posted / sri

BY USING SOURCE QUALIFIER

Is This Answer Correct ?    6 Yes 63 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1656


Explain the difference between mapping parameter and mapping variable?

607


Explain what are the different types of transformation available in informatica.

575


Name at least 5 different types of transformations used in mapping design and state the use of each.?

672


What is a standalone command task?

658






Describe the impact of several join conditions and join order in a joiner transformation?

649


What is rank transform?

604


What is blocking transformation?

723


Explain the etl program with few examples.

548


differences between service based and product based?

1568


what is the difference between informatica6.1 and infomatica7.1

1722


Enlist the tasks for which source qualifier transformation is used.

593


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1468


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1626


What is a surrogate key?

563