channu

• Oct 3rd, 2006

Hi ....           I agree with u, can u explain me 3rd answer i.e to convert row to columns using Normalizer transformation.  plz

priya

• Sep 27th, 2006

1)Sequence generates only numeric values as sequence but not char or date whereas in other tools like OWB they can generate sequence of Date also2)Sometimes an element that occurs multiple times is a ...

Answer Question  Select Best Answer

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific subject are called datamartsBottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 13th, 2009

Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...

Answer Question  Select Best Answer

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

hey kiran,   u can solve this problem by using mapping variable where u need to mention the start value and end value.when u end ur session then that variable will take the next value as the...

abdulla

 Profile Answers by abdulla Questions by abdulla

• Aug 19th, 2006

hi,  u can use mapping variable concept for this.

Answer Question  Select Best Answer

hanimi

 Profile Answers by hanimi Questions by hanimi

• Apr 28th, 2011

Bulk load the dwh server bypass the data to the target, in that we have session performance improves.in normal load data moves the database log file.

Ray

• Mar 22nd, 2006

Also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

kumar

• Sep 28th, 2006

For loading data in to other dimensions we have respective tables in the oltp systems..But for time dimension we have only one base in the OLTP database. Based on that we have to load time dimension. ...

Answer Question  Select Best Answer

Racp238

 Profile Answers by Racp238 Questions by Racp238

• Apr 3rd, 2008

Why not just use an inline select statement in your sql qualifier to eliminat the overhead of a lookup transformation all together?

Vani_AT

 Profile Answers by Vani_AT Questions by Vani_AT

• Apr 3rd, 2008

Connected and Unconnected lookups have their own pros and cons.Unconnected lookup is designed for a specific purpose.The task that an unconnected lookup does can be done by a connected lookup also. Th...

Answer Question  Select Best Answer

Why Union transformation is active while it returns same number of rows as in the sources?

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 18th, 2010

Union transformation is an active transformation and it does changes the number of records.Suppose source has following columns:Name, School, CollegeABC, SKM, IIT-DXYZ, DAV, IIMThere are total 10 rows...

harikr

 Profile Answers by harikr Questions by harikr

• Dec 1st, 2009

An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.Union Transformation does UNION ALL; hence...

Answer Question  Select Best Answer

ahammed

 Profile Answers by ahammed Questions by ahammed

• Aug 2nd, 2010

First load the data into dimension table. If all the dimension data loaded is succeded then only load all dimension tables data into fact table.

shekhar.aadi

 Profile Answers by shekhar.aadi Questions by shekhar.aadi

• Jul 22nd, 2010

We are using mapplets and joiner transformation is used for mapplet.

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 13th, 2010

For a banking domain if we are Maintaining customer infowarehouse the size of DB is 9GB1.4 dimensions-Customer,period or time,productand promotion2.7 fact tables3.approx min 45 mappings

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

I think the interviewer wants to the number of facts and dimensions in the warehouse, and not the size in GB's or TB of the actual Database.

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

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

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

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

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

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

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

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

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

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

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