My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
3 5578There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
3 7185I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
HCL,
4 7083Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
1 3960HAI 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
1513Post New Informatica Questions
Explain pushdown optimization $pushdownconfig parameter - informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is rank index in rank transformation?
How do you set a varible in incremental aggregation
What the difference is between a database, a data warehouse and a data mart?
Explain about Informatica server process that how it works relates to mapping variables?
Which transformation should we use to normalise the COBOL and relational sources?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is workflow manager?
Define sessions in informatica etl?
What does refresh system mean, and what are its distinctive choice?
Can we create a Integration service without a Repository service and vice versa?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the issues you have faced in your project? How did you overcome those issues?
What is the difference between source qualifier transformations source filter to filter transformation?
