How to display null values on a target & non-null values on
a target?
Answer Posted / murugan
normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
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
What happens when a session fails and you click on recover?
What is the meaning of up gradation of repository?
Explain in detail about scd type 1 through mapping.
Where is metadata stored?
What is a joiner transformation and why it is an active one?
Explain in detail scd type 2 through mapping.
COM components can be used in Informatica
What are the types of presistent cache in look up tr.
How to do unit testing in informatica?
Global and Local shortcuts. Advantages.
Explain the difference between a data warehouse and a data mart?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the function of aggregator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not