which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
6 10736i 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 6555i 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 4041Hello , 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.
2861i 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 10868SOURECE 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 4848tell 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 26143i 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 7197i 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 11988Post New IBM Informatica Interview Questions
Define CableServe
Describe the different XAML files generated when a new project in Silverlight Visual Studio is created
What topics cover the study of biomedical sciences?
What is .net code security?
What is the default left margin?
You are a project manager for Capella Systems. Your company writes custom software for accounting and financial systems for medium- to large-sized corporations. Your recent project has experienced some setbacks, and you've been forced to rework the design of one of the programs because it doesn't match the customer's requirements. Since some parts of the program have already been written, it will have to be rewritten so that it matches the design changes. This rework has increased costs, and you're beginning to notice some signs of poor morale because of the rework. Which of the following is true? A. The problems occurred because the WBS was not constructed properly. B. The quality assurance plan was carried out correctly, which is how the design problems were discovered. C. The problems occurred as a result of poor scope definition. D. The Risk Management Planning process details these kinds of risks and the responses you should put into place should they occur.
You used a word 'career growth', How will you measure it? What is the highest position in banking?
What is the default time for group policy refresh interval time?
What are jsp implicit objects?
what other sas products have you used and consider yourself proficient in using? : Sas programming
how much one carpenter can doing shuttering of slab in one day
I don't have websphere installed on my web server how do I add to the websphere administration console ?
How do I choose a window color?
Which type of object requires this object?
What is the default fill factor value?