What is the status code?
Answer / swetha
Status code provides error handling for the informatica
server during the session. The stored procedure issues a
status code that notifies whether or not stored procedure
completed sucessfully. This value can not seen by the user.
It only used by the informatica server to determine whether
to continue running the session or stop.
| Is This Answer Correct ? | 5 Yes | 0 No |
Design time, run time. If you don't create parameter what will happen
what is $$$$?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
how the informatica server sorts the strings values in rank transformations?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is the benefit of partitioning a session?
What is synonym?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Explain what is informatica metadata and where is it stored?
Explain informatica architecture - version 8 / 9
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance