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 / surendra

Please give the exact requirement

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What you know about transaction control transformation?

646


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1162


Mention a few design and development best practices for informatica?

657


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

700


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5780






What is the difference between stop and abort in informatica

760


On which transformations you created partitions in your project?

870


Explain informatica architecture - version 8 / 9

758


Explain what transformation and how many are there in informatica?

587


What are the transformations that are not supported in mapplet?

682


How many types of sessions are there in informatica.please explain them?

776


What is confirmed fact in dataware housing?

5914


Enlist the tasks for which source qualifier transformation is used.

669


Make a note of the quantity vaults made in informatica?

655


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3604