there is a comma separated flat file as source and there is a column in that on

there is a comma separated flat file as source and there is
a column in that one field is having space like "rama
krishna" like that what happens when this is used as source

Question Posted / anirvin2009

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

Answers were Sorted based on User's Feedback

there is a comma separated flat file as source and there is a column in that one field is having sp..

Answer / srinivas

i have tested when we use coma seperated file it should
take only rama krishna as single column

Is This Answer Correct ?

23 Yes

0 No

there is a comma separated flat file as source and there is a column in that one field is having sp..

Answer / kishore

Hi,

I think ...it will take separate column when comma(,) occurs
only..... "rama krishna: as single column only....

Is This Answer Correct ?

11 Yes

1 No

Post New Answer

More Informatica Interview Questions

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers Cognizant,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers HCL,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers Amex,

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers ACS,

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers TCS,

Differentiate between sessions and batches?

0 Answers

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers Puma,

can we generate reports in informatica ? How?

3 Answers

Write the different tools in the workflow manager?

0 Answers

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers

For more Informatica Interview Questions Click Here