How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
2 9378How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 38608we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
2 6281Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
2123In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
2 24003why cant we put a sequence generator or upd strategy transformation before joiner transformation?
2 18067Post New Informatica Questions
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the prerequisite tasks to achieve the session partition?
What is the difference between a connected look up and unconnected lookup?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Implementation methodology
Different sorts of metadata that stores in the storage facility?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is option by which we can run all the sessions in a batch simultaneously?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are multi-group transformations?
What is expression transformation?
One 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?
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
How might one distinguish in the case of mapping is right or not without associating session?
Explain lookup transformation is active in informatica