if i have a delimited file as source so how can we seperate this file into three

if i have a delimited file as source so how can we seperate this file into three diff targets?

Question Posted / mehul.thakur

2 Answers
5358 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if i have a delimited file as source so how can we seperate this file into three diff targets?..

Answer / lakshmi

using expression ,transaction control transformations

Is This Answer Correct ?

0 Yes

0 No

if i have a delimited file as source so how can we seperate this file into three diff targets?..

Answer / guest

Try with Router transformation.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More Informatica Interview Questions

How to do unit testing in informatica?

0 Answers

why union transformation is active transformation?

6 Answers IndiGo, TCS,

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers BirlaSoft,

Performance tuning in UNIX for informatica mappings?

0 Answers CGI, CTC,

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers Amdocs,

what is dynamic cashe

3 Answers Informatica,

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers Accenture, HCL,

How Union Transformation is an Active Trans?

6 Answers

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers Wipro,

What are the methods for creating reusable transforamtions?

2 Answers

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers

For more Informatica Interview Questions Click Here