What are ETL Tools?
No Answer is Posted For this Question
Be the First to Post Answer
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
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 are mapping parametres and variables in informatica?
Explain the code page compatibility?
what is the purpose of surrogate key and diff between primary key&surrogate key
I have source like this 1:2;3. so i want to load the target as 123
how to get max value record into one target and remaining records into another target?
How You Pull the records on daily basis into your ETL Server.
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?