which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
6 10440i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
2 6425i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
1 3941Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
2796i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
7 10562SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
1 4731tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
3 25959i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
3 7031i 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...
6 11778Post New IBM Informatica Interview Questions
What is partial view in mvc?
What is the purpose of @typeconversion annotation annotation?
Which method do you follow to get a record from a million records? (Searching not from database, from an array in php)?
What is the function of the generator exciter?
What is radio group?
it is better to invest in which securities short term/long term or both? please reason4 the same
What is file extension of Webservices in .Net?
What is normal form in dbms?
What are accessories in computer?
CALCULATE THE TOTAL VOLTAGE DROP AND SELECT THE CABLE SIZE IN MM-SQARE FOR A PANEL-262KW AT 110 METER FROM THE SOURCE SUPPLY , SUPPLY VOLTAGE 240/415
What are your plans for higher studies?
what is the difference b/w 4.6c & 4.7EE?
Does chkdsk fix corrupt files?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is difference between fiber otical cable and cat cable?