Answer Posted / abhishek guddu
DECODE FUNCTION YOU CAN FIND IN SQL BUT IIF FUNCTION IS NOT
IN SQL. DECODE FUNCTION WILL GIVE CLEAR READABILITY TO
UNDERSTAND THE LOGIC TO OTHER.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the settings that you use to configure the joiner transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a stored procedure transformation?
Can we create multiple integration service on single repository?
What is deployment group?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is source qualifier transformation in informatica?
Mention a few design and development best practices for informatica?
To import the flat file definition into the designer where should the flat file be placed?
What is a joiner transformation and why it is an active one?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to update source definition?
