Interested to Buy Any Domain ? << Click Here >> for more details...
How to display null values on a target & non-null values on
a target?
- 3 Answers
- 8914 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh.b
hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.
source-->sq-->expression-->router-->2 targets
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Implementation methodology
How to update or delete the rows in a target, which do not have key fields?
How can you increase the performance in joiner transformation?
how will you remove the duplicate records from flat file without using sorter?
can a port in expression transf be given the name DISTINCT
why union is active transformation?
Enlist some properties of sessions.
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Explain sql transformation in script mode examples in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
While migrating the data from one environment to another environment how would you manage the connections?
Tell me one complex query in oracle ?
Teradata 
