Interested to Buy Any Domain ? << Click Here >> for more details...
Why we use partitioning the session in informatica?
- 2 Answers
- 14310 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.
| Is This Answer Correct ? | 14 Yes | 8 No |
Answer / honey
The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments
| Is This Answer Correct ? | 3 Yes | 0 No |
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
tell me 7.x and 8.x diferrencess(but not transformations)
in which situations do u go for sequence generator ?
What are the types of lookup?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Teradata 
