How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
2 5164i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
IBM,
6 11980One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
TCS,
2261Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
3 9083Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
3 14273i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
2 7289following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
TCS,
4 8359Post New Informatica Questions
How do you load only null records into target?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are 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 is the use of transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the command used to run a batch?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is confirmed fact in dataware housing?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between informatica 7.0 and 8.0?
What is enterprise data warehousing?
Differentiate between reusable transformation and mapplet.
What is the meaning of decode in informatica?
What is the Process to creating lookup transformation in informatica
What is the function of look up transformation?