What are the restrictions of union transformation?
No Answer is Posted For this Question
Be the First to Post Answer
How to do the error handling of if ur source is flatfiles?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
What is sequence generator transformation in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What are Dimensional table?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
How to run a session, which contains mapplet?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.