Interested to Buy Any Domain ? << Click Here >> for more details...
Source table
-------------
ID NAME
--- ------
101 PANKAJ
NULL KUMAR
NULL MATHUR
102 JYOTI
NULL SAXENA
103 SACHIN
NULL TENDULKAR
TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR
IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
- 2 Answers
- 6764 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / keshav
CREATE AN EXPRESION TALE 2 VARIABLE AND 2 OUTPUT PORTS
FOR VARIABLE PORTS WRITE THE BELOW EXPRESSIONS
V_NAME(v)=IIF((IIF(ISNULL(ID),V_ID,ID)=V_ID),V_NAME || ' ' || NAME,NAME )
V_ID(v)=IIF(ISNULL(ID ) , V_ID, ID )
OUT_ID(o)=V_ID
OUT_NAME(o)=V_NAME
AFTER TAKE AGGREGATER AND SELECT OUT_ID AS GROUP BY PORT
AFTER CONNECT TO TARGET
| Is This Answer Correct ? | 4 Yes | 1 No |
HI FRIENDS........
Please check this answer....
source table has 2 columns id,name.pass to expression .
remove o/p port in name column,take another port select only o/p port, write code in side of the port
REPLACECHR(0,NAME,'NULL',' ')
pass to target. mapping like
SD=>SQ=>EXP=>TGT.
| Is This Answer Correct ? | 0 Yes | 0 No |
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Different qualification between a related rotate toward the sky and isolates look upward?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
In a table, 4 person having same salary. How to get Third person record only?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
Why union transformation is an active transformation?
Briefly define reusable transformation?
Define informatica repository?
Do you find any difficulty while working with flat files as source and target?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
How can you define user defied event?
what is hash table in informatica?
Teradata 
