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/
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
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain Dataware house architecture .how data flow from intial to end?
How to Create a folder using pmrep command?
how to load rows into fact table in data warehouse
What are the different lookup cache(s)?
Performance tuning in UNIX for informatica mappings?
What is session task and command task?
What is workflow manager?
Is it possible to create multiple domains on a single Informatica server?
What is olap (on-line analytical processing?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to start a workflow using pmcmd command?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??