ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO
CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF
RUNNING ?

Answers were Sorted based on User's Feedback



ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / divi

I think we can change it in session properties of mapping
tab.if select flatfile on top of that we see set file
properties.

Is This Answer Correct ?    15 Yes 0 No

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / bsgsr

hi, divi,
ur access to the subject is cool.
i go with your answer.
thanks.

Is This Answer Correct ?    0 Yes 3 No

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / abhinav

@Divi: I did not understand your answer. Can somebody
please explain what exactly did Divi suggest doing?

I can only think of using a pre-session shell script to
replace all commas with any other delimiter.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


Can we override a native sql query within informatica?

0 Answers  


What is active and passive transformation?

10 Answers  






There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


Which kind of index is preferred in DWH?

3 Answers  


Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,


What is a code page?

0 Answers  


What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


Categories