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
- 4 Answers
- 13423 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the mapping parameters and mapping variables?
What are the different lookup cache(s)?
Define joiner transformation?
Briefly explain the aggregator transformation?
Enlist the advantages of informatica.
What do you mean by blocking transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
which one is better performance wise joiner or look up
Enterprise data warehouse your projects phase by phase explain?
What is rank index in rank transformation?
How to create or import flat file definition in to the warehouse designer?
What are the types of data warehouses?
What is Session and Batches?
