Answer Posted / koti
in correlated query is nothing but a sub query, but the difference is sub query can executes first, based on the result the main query executes...
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Enterprise data warehouse your projects phase by phase explain?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is data caches/ index caches?
Explain incremental aggregation in informatica
What's the layout of parameter file (what does a parameter file contain?)?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to use pmcmd utility command?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How do you manage the Parameter files while migrating your data from one environment to another environment?
can you please explain me pre session and post session options?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
can u give example for factless fact table
What is the maplet?