Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Can anyone tell me, when a flat file contains different
kinds of delimeters available for each line ( For Ex: First
line contains [,*&#$] and second line contains [%@$#%^].
Like that all records having different kinds of delimeters.
How can we implement this kind of flat file in informatica?

Answers were Sorted based on User's Feedback



Can anyone tell me, when a flat file contains different kinds of delimeters available for each line..

Answer / murali udayagiri

Write a pre-process shell script by using the below 2nd
command and overwrite to another file, use overwritten file
as source for loading.

1)
$ cat multi_delimeter.txt
1,murali%100#10
2%krishna#200,20
3%sasi%232,10
1%murali%100,30
4,krish,200%20

2)
$ sed -e 's/,/|/g' -e 's/%/|/g' -e 's/#/|/g' multi_delimeter.txt
1|murali|100|10
2|krishna|200|20
3|sasi|232|10
1|murali|100|30
4|krish|200|20

Thanks,
Murali Udayagiri

Is This Answer Correct ?    3 Yes 0 No

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line..

Answer / zaheer

One more thing, its possible for a flat file when delimeters
are common or same for each and every record by mentioned in
flat file wizard. But just thing is there any other process
to do above first question

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332

3 Answers   IBM, Mphasis,


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

2 Answers   TCS,


What are pre and post-session shell commands?

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


Explain pushdown optimization and types in informatica

0 Answers   Informatica,






What is primary and backup node?

0 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


how to obtain performance data for individual transformations.

2 Answers  


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


Explain the types of transformations?

0 Answers  


If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  






Categories