How to extract original records at one target & Duplicate
records at one target?

Answer Posted / amrita

can you tell me scèneario.

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1480


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

1719


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

3775


How to open an older version of an object in the workspace?

618


Explain dynamic target flat file name generation in informatica

651






What is the format of informatica objects in a repository?

603


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554


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?

633


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4314


How can we update a record in the target table without using update strategy?

658


How to use procedural logic inside infromatica?

638


How can we create index after completion of load process?

600


Briefly define reusable transformation?

625


Explain load alternative records / rows into multiple targets - informatica

689


have u done any performance tuning? how u ll do?

1861