Interested to Buy Any Domain ? << Click Here >> for more details...
explain about session partitions ?
- 1 Answers
- 5779 Views
- I also Faced
- E-Mail Answers
Answer / chandrababu.sarupuru
Partition's can be done on both relational and flat files.
Informatica supports following partitions
1.Database partitioning
2.RoundRobin
3.Pass-through
4.Hash-Key partitioning
5.Key Range partitioning
All these are applicable for relational targets.For flat
file only database partitioning is not applicable.
Informatica supports Nway partitioning.U can just specify
the name of the target file and create the partitions rest
will be taken care by informatica session.
| Is This Answer Correct ? | 2 Yes | 0 No |
Why is meant by direct and indirect loading options in sessions?
Name 4 output files that informatica server creates during session running?
Can we run session without using workflows?
What are the components of the workflow manager?
How can repository reports be accessed without sql or other transformations?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is surrogate key?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
How can you access the remote source into your session?
Performance wise which is better joiner or look up ? Give me with example?
Teradata 
