vizaik

 Profile Answers by vizaik Questions by vizaik

• Apr 11th, 2007

For a project, there will be: 1.BRD(Business Requirement Document)-BA 2.SSSD(Source System Study Document)-BA BRD consists of the requirements of the client. SSSD consists of the source system study...

Answer Question  Select Best Answer

kalyan

• May 1st, 2006

Stop: In this case data query from source databases is stopped immediately but whatever data has been loaded into buffer, there transformations and loading contunes. Abort: Same as Stop but in this case maximum time allowed for buffered data is 60 Seconds.

kalyan

• May 1st, 2006

Stop: In this case data query from source databases is stopped immediately but whatever data has been loaded into buffer, there transformations and loading contunes.Abort: Same as Stop but in this case maximum time allowed for buffered data is 60 Seconds.

Answer Question  Select Best Answer

Reddy

• Mar 6th, 2006

ya Its Posible using pmcmd Command with out using the workflow Manager run the group of session.as per my knowledge i give the answer.

Answer Question  Select Best Answer

girish

• Mar 16th, 2006

Use sequence genetrator transformation

Sudip

• Mar 10th, 2006

if data in tables as follows Table AKey-1 char(3);table A values_______123Table Bbkey-a char(3);bcode  char(1);table b values1 T1 A1 G2 A2 T2 L3 Aand output required is as1, T, A2, A, T, L3, Athe...

Answer Question  Select Best Answer

kalyan

• May 1st, 2006

To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.

satyambabu

• Mar 22nd, 2006

Maintain the history data and maintain the most recent changaes data.

Answer Question  Select Best Answer

Arvind

• Apr 11th, 2006

How can you edit the parameter file? Once you setup a mapping variable how can you define them in a parameter file?

SSekar

 Profile Answers by SSekar Questions by SSekar

• Mar 17th, 2006

If we need to change certain attributes of a mapping after every time the session is run, it will be very difficult to edit the mapping and then change the attribute. So we use mapping parameters and ...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• May 12th, 2008

Besides the reusability of a worklet as mentioned above, we can also use a worklet to group related sessions together in a very big workflow.  Suppose, we have to extract a file and then load a fact table, in the workflow we can use one worklet to load/update dimensions.

Shanmugam

• Jul 6th, 2006

Worklet is reusable workflows. It might contain more than on task in it. We can use these worklets in other workflows.

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

If u r taking the dimension table it has the master data like product id, product name, product description dimention are three types conformed dimention, junk dimention and  degenerate dimention.If u r taking facttable it contains the measures like sales revenue,price  and discount.

ravi kumar guturi

• Mar 17th, 2006

In the fact table contain measurable data and less columns and meny rows,It's contain primarykeyDiffrent types of fact tables:additive,non additive, semi additiveIn the dimensions table contain textual descrption of data and also contain meny columns,less rowsIts contain primary key

Answer Question  Select Best Answer

suresh

• Mar 17th, 2006

You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary l...

Answer Question  Select Best Answer

venu adavelly

• Sep 14th, 2007

Take 1 dimension as a source and take look up on remanning dim's pass only the primarykeys of the dim's to the fact table and also you can pass the measuer's. Don't think it's various from other mapping.

Hareesh

• Apr 3rd, 2006

Kishore,yaa, dimension table has to be treated as a source, but how 'n' dimensions will be loaded into a single fact table.like do we use the one dimesion as a source and other dimnsions as a look up table we will load?or else any other logic we will implement?Hareesh

Answer Question  Select Best Answer

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• May 7th, 2007

Power centre includes data partitioning and multi server registrationswhere as power mart does not include those

ramana

• Apr 30th, 2006

pc  =========1                             &n...

Answer Question  Select Best Answer

chinap24

 Profile Answers by chinap24 Questions by chinap24

• Apr 11th, 2008

Using an update strategy transformation...We can insert the new rows using INSERT option in T1 and insert duplicate rows using UPDATE option in T2

sri.kal

 Profile Answers by sri.kal Questions by sri.kal

• Apr 10th, 2008

We  can achieve this by using router t/r.

Answer Question  Select Best Answer

shyamjamisetty

 Profile Answers by shyamjamisetty Questions by shyamjamisetty

• Mar 22nd, 2008

u mean only look up trf and not any other transformations? be clear? if not one senario is that , we can use multiple connected loopup trf ,depending upon the target.if u have different wh_keys in ur ...

Neha

• Apr 3rd, 2006

Use unconnected lookup if same lookup repeats multiple times.

Answer Question  Select Best Answer

Abhik

• Sep 21st, 2006

In Database parlance you can define a domain " a set of all possible permissible values for any attribute".Like you can say the domain for attribute "Credit Card No#" consists of all possible valid 16 digit numbers.Thanks.  

Ashish

• Jul 28th, 2006

Domain in Informatica means - A central Global repository (GDR) along with the registered Local repositories (LDR) to this GDR. This is possible only in PowerCenter and not PowerMart.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: sm1506

• Apr 7th, 2006

---

Rank:
1
2<--2nd position
2<--3rd position
4
5

Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.

Dense Rank:
1
2<--2nd position
2<--3rd position
3
4

Same ranks are assigned to same totals/numbers/names. the next rank follows the serial number.

sm1506

• Apr 7th, 2006

Rank:12<--2nd position2<--3rd position45Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.Dense Ra...

Improve Answer

Shanmugam

• Jul 6th, 2006

Incremental aggregation is specially used for tune the performance of the aggregator. It captures the change each time (incrementally) you run the transformation and then performs the aggregation func...

maverickwild

 Profile Answers by maverickwild Questions by maverickwild

• Apr 10th, 2006

When you use aggregator transformation to aggregate it creates index and data caches to store the data 1.Of group By columns 2. Of aggreagte columnsthe incremental aggreagtion is used when we have his...

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

By using Custom transformation we create the single input ports and mulple output ports or mulple input ports and single inport otherwise mulple input or output ports. when we cliking the custom trans...

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

Complex mappings means not a map with more than 100 transformations used in.Even 5 transformations used mapping also called complex enough.It depends on business logic. If the requirement has too much...

Usha

• Nov 29th, 2006

In real time as per business logic we need to build the mapping using number of transformations, for example if you are trying to pass millions of rows with number of transformations and writing sql o...

Answer Question  Select Best Answer

What is the responsibility of a Informatica production support member?

Senthilkrishnan

 Profile Answers by Senthilkrishnan Questions by Senthilkrishnan

• Nov 16th, 2009

1) Have to monitor the scheduled jobs or run the workflows and scripts which needs to run the day.2) If any issues or job fails, Immediately check the logs and contact with support team if needed. Fre...

DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 26th, 2009

Production support means, whenever a problem/Error rises while the product is running we have to identify that problem/Error and solve it, or intimate about that problem/Error to the concern perso...

Answer Question  Select Best Answer

Use sorted input.

manoj_behera82

 Profile Answers by manoj_behera82 Questions by manoj_behera82

• Jul 20th, 2010

1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.2. Reduce the input/output ports in the aggregator.3.Can try increasing the cache size.

job_infa

 Profile Answers by job_infa Questions by job_infa

• Jan 28th, 2009

-Use sorted input to decrease the use of aggregate caches.-Limit connected input/output or output ports.Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.-Filter the data before aggregating it.

Answer Question  Select Best Answer