How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
2 3564i 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 9089One 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,
1585Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
3 7211Can 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 12234i 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 5798following 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 6360Post New Informatica Questions
In informatics server which files are created during the session rums?
What is dimensional table? Explain the different dimensions.
What are mapplets?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can u generate reports in Informatica?
What are Dimensional table?
Explain in detail about scd type 1 through mapping.
What can we do to improve the performance of informatica aggregator transformation?
What is sorter transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the reusable transformations?
Explain the features of connected and unconnected lookup.
What are the databases that informatica can connect to windows?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
