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 / rajesh bathini
seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where can we find the throughput option in informatica?
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 is the format of informatica objects in a repository?
What is a snowflake schema?
What is a rank transform?
What the difference is between a database, a data warehouse and a data mart?
What is Index Caches size?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Define filter transformation?
What is informatica?
Define update strategy?
Can we create two repositories on same database instance in oracle?
What is an unconnected transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the new features of informatica 9.x at the developer level?