Interested to Buy Any Domain ? << Click Here >> for more details...
i have one table like
cust_id ph1 ph2 ph3
1002 9290123526 97671927210 9876545232
we use Normalizer wt is o/p?
sue normalizer we can generate three tables in single table/
- 4 Answers
- 7530 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehul thakur
In normalizer tab of normalizer tr. set no of occurence to 3
since we have 3 phno,which in turn create 3 i/p port in port tab,u hav to create exp tr. betn normalizer and target and map GCID_phno to expression tr. say out_phno and give condition in expression like decode(GCID_phno,1002,9290123526,1002,97671927210,1002,9876545232);
It might help u
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain sql transformation in script mode examples in informatica
What are the different types of transformation available in informatica.
Name the different lookup cache(s)?
Explain the aggregator transformation?
what is INFORMATICA TESTING process
What is informatica worklet?
How to extract the informatica rejected data?
Clarify the aggregator change?
What is the use of source qualifier?
How do you load only null records into target? Explain through mapping flow.
What is a joiner transformation?
Parameter and variable differences
Explain what transformation and how many are there in informatica?
