Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7160 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 4 Yes | 0 No |
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 |
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
what is datamart
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what is lookup chache?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
How do you take care of security using a repository manager
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is the difference between Bulk Load and Normal Load
What is the meaning of up gradation of repository?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Can anyone briefly describe abt audit table loading?
Teradata 
