How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
2 3901i 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 9937One 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,
1743Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
3 7681Can 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 12855i 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 6144following 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 6922Post New Informatica Questions
What is informatica etl tool?
How to delete duplicate row using informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Difference between Data and Index Caches?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Briefly describe lookup transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
how we can load rejected record's at run time?(not through bad files)
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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?
Tell me about Propagate functions in informatica
What are multi-group transformations?
What is the function of union transformation?
In informatics server which files are created during the session rums?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?