what are all the deliverables of ETL informatica power center project?
what are all updated or created by etl developer as his everyday activities?
No Answer is Posted For this Question
Be the First to Post Answer
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
why dimenstion tables are denormalized in nature ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What are the different tools in workflow manager?
what is normalizer transformation?
If we have lookup table in workflow how do you trouble shhot to increase performance?
in a table it has 200 rows the query is select 150 from tablename.whats the output
Difference between Target-based loading and constraint-based loading?
What is Cognos script editor?
What is fact table? Explain the different kinds of facts.