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
- 6541 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the new features of informatica 9.x at the developer level?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to elaborate powercenter integration service?
How to generate sequence numbers without using the sequence generator transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are Dimensional table?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is different between the data warehouse and data mart?
What is intricate mapping?
whats the logic to load the lower level of granularity of data to fact table.
Explain how to import oracle sequence into informatica?
What is a rank transform?
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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
