What is the Process to creating lookup transformation in informatica
No Answer is Posted For this Question
Be the First to Post Answer
How can you access the remote source into your session?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
what is the purpose of surrogate key and diff between primary key&surrogate key
Hi All can anyone tell me where i will get Informatica training in Mumbai?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
When the informatica server marks that a batch is failed?
My source table having some records ,i want load 1st record and last record into one target?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Which development components of informatica have the highest usage?
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.