how can you load data into target table without leading zeor's
Answer Posted / asjad
trim(Col_Nm,'0',L)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
As union transformation gives UNION ALL output, how you will get the UNION output?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by active and passive transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is different between the data warehouse and data mart?
State the differences between sql override and lookup override?
If informatica has its scheduler why using third party scheduler?
4 yrs etl devloper roles and responsibilities?any body give solutions
How union transformation is used?
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
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is a repository? And how to add it in an informatica client?
When do you use sql override in a lookup transformation?