supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How
Answer Posted / bsgsr
hi, sri krishna
gud thinking,
cn i have ur mail id or contact number
my no 9866188658
bsrinivas1213@gmail.com
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
define galaxy repository in informatica
What is option by which we can run all the sessions in a batch simultaneously?
Which transformation should we use to normalise the COBOL and relational sources?
What is data movement mode in Informatica and difference between them?
what is the complex transformation you used in informatica
What are the different types of repositories created using informatica?
Explain direct and indirect flat file loading (source file type) - informatica
design of staging area?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is depict expression change?
What is the meaning of up gradation of repository?
What are the new features of informatica 9.x in developer level?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the different types of transformation available in informatica.
Can anyone tell me the new features in Informatica 9 Version?