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
What are the components of workflow manager?
How do you load unique records into one target table and duplicate records into a different target table?
How to differentiate between the active and passive transformations?
What are the static cache and dynamic cache in informatica?
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
How is union transformation utilized?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can we create two repositories on same database instance in oracle?
What is transformation?
What is the procedure for creating independent data marts from informatica 7.1?
expain about the tune parameters?
tell me 5 session failure in real time how can you solve that in your project?
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 will be the approach?
What is domain in terms of informatica?