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
- 7243 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
In informatica workflow manager, how many repositories can be created?
What is Data Caches size?
How to elaborate powercenter integration service?
How are indexes created after completing the load process?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the static cache and dynamic cache in informatica?
Enlist few areas or real-time situations where informatica is required.
what is SDLC way of code development?
How to load last n records of file into target table - informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Enlist some properties of sessions.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Did u used latest transformations of 8.6.0? for what?
How do you remove duplicate records in informatica? And how many ways are there to do it?
