what is degenerated dimension?1 2596
what is constraint based loading2 4758
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?6 7525
i 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 4862
i 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 guidence1 2730
Hello , 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.1917
I want skip first 5 rows to load in to target? what will be the logic at session level ??1 5381
i 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 6782
SOURECE 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 3248
tell 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 20334
What are events in workflow manager?1 7198
Does Facttable Normalized or Denormalized?2 6263
i 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 5040
i 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 8101
How to fix the etl bugs..Tell me the process?1 2256
What is parameters in c#?
Is swift difficult to learn?
What could be done in order to stop the pivot table from losing the column width while refreshing?
Transformer diagram mention each parts ?
I want to calculate how much capacitor we connect to maintain the unity power factor? Is there any formula? Pls give me the answer
What is harvesting in agriculture?
What is Overloading ? Is it similar to overriding ?
As per standard, transformer body earthing and other Equipment earthing (Equipment earthing) did not connect. but in LT side termination we are doing metal glanding in both side Transformer to PCC Panel through armoured cable, now X'mer body earthing and PCC Pane earthing (Equipment earthing) both are connect.is this safe for X'mer or other equipment?
What can be a reason for the solaris system slowing down?
How do I force delete a folder in windows?
Explain the difference between collector & emitter of transistor, even though material used for both same?
What is the difference between abstract classes and interfaces?
What is the difference between substr & instr functions?
Can I buy just word and excel?
How can we view last record added to a table?