srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

I think this question is belongs to congnos.

Answer Question  Select Best Answer

I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...

prasoon

• Aug 7th, 2006

hi1i would like to share something more about Look ups.We  have connected ,unconnected look up and static and dynamic look ups.dynamic look ups are very useful when we need to perform insert or u...

bala

• Jul 27th, 2006

Hi Kalpana,Stored Procedure Transformation : It is a passive and both connected and unconnected transformation. It is useful to automate time consuming tasks and also used to create and drop the index...

Answer Question  Select Best Answer

anonymousjoe

• Feb 9th, 2007

Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools.

Answer Question  Select Best Answer

raj

• Feb 23rd, 2007

We take source data from databae like oracle or any other database .. 1 st we take source data in import option in source section in desginer... ok thanks

Answer Question  Select Best Answer

When i start the informatica services for loading in workflow manager, the informatica services shows running status but when i see the properties service, status has stooped. With-in sec services has stopped when i was trying to start the services for informatica, how can i overcome this problem?

vamsi

• Dec 31st, 2006

first u start the Informatica repository server service and then u start the informatica service in services.try it it may work.bye

Answer Question  Select Best Answer

venkat

• Sep 19th, 2006

1.can u explain one critical mapping?Ans: Reading from multiple sources and writing to multiple targets using number of TLP's and applying complicated business rules then it is a challe...

prasoon

• Aug 7th, 2006

hi!it depends on your data and the type of operation u r doing.If u need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup.Or,if it ...

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 14th, 2006

We can't say which questions asking in which round that will depending on the interviewer.  In Hr round they will ask what about ur current company, tell some thing about ur company and why ...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

If the join condition between the tables is wrong, you will get cartesian product.

Srinivas

• Aug 29th, 2006

Generate the SQL in SQ Transformation and try to run the same in TOAD.

Answer Question  Select Best Answer

*Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.*Aggregator Transformation: If you use sorted ports you cannot partition the associated source*Joiner Transformation: you can not partition the master source for a joiner transformation*Normalizer Transformation *XML targets.

srinivas vadlakonda

• Oct 11th, 2006

Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.Aggregator Transformation: If you...

Manasa

• Sep 7th, 2006

1)source defination
2)Sequence Generator
3)Unconnected Transformation
4)Xml Target defination

Answer Question  Select Best Answer

nayana

• Sep 12th, 2006

I did the same, its advising invalid mapping :(

manichamp123

 Profile Answers by manichamp123 Questions by manichamp123

• Sep 12th, 2006

Nayana,You need to create input port to take the input in_customer_id then from your source flow i.e. from the expression you can call the unconnected lookup :LKP.lkp_customer(customer_id) then in unconnected lookup condition you can put the condition like in_customer_id=customer_id

Answer Question  Select Best Answer

R

• Sep 26th, 2006

I think fact table contains foreign keys which are primary keys in dimension tables other than facts and measures.

Motilal

 Profile Answers by Motilal Questions by Motilal

• Sep 15th, 2006

All the primary keys of the connected dimension tables as foreign keys.

Answer Question  Select Best Answer

Abhishek

• Sep 21st, 2007

We can add header and footer record in two ways.1) Within the informatica session we can sequence the data as such that the header flows in first and footer flows in last. This only holds true wh...

Answer Question  Select Best Answer

rajarajana

 Profile Answers by rajarajana Questions by rajarajana

• Sep 26th, 2006

Hi,        Just check out this following link you will get good informationhttp://www.informatica.com/services/education_services/certification/faq/default.htm#one

opbang

 Profile Answers by opbang Questions by opbang

• Sep 25th, 2006

Good, you are working in informatica, but you are working with only part of informatica or whole informatica.  If your job is only related to staging area, developing ETL and running the mapping ...

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

if you selected commit type is target, once the cache is holding some 10000 records server will commit the records, here server will be least bother of the number of source records processed. if you s...

srinivas vadlakonda

• Sep 29th, 2006

Commits the data based on the course records

Answer Question  Select Best Answer

sandeep

• Feb 2nd, 2007

Install informatica server side 1st then at time of installation create repository and integration service, you can create repository and integration service after installation install client side, c...

Answer Question  Select Best Answer

jyoti

• Jan 9th, 2007

yes we can access data from previous version of repository from latest version.regardsjyoti

Answer Question  Select Best Answer

kareem

• Oct 16th, 2006

Presistent cache stored in the server folder

Vamsi Krishna.K

• Oct 1st, 2006

The informatica server saves the cache files for every session and reuses it for next session, by that the query on the table will be reduced, so that there will be some performance increment will be there.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 11th, 2006

transaction can occur without the measure fore example victim id

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Factless Fact table are fact table, which is not having any measures.  For example  - You want to store the attendance information of the student.  This table will give you datewise, wh...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

Besides session log, it also creates the following files if applicable - reject files, target output file, incremental aggregation file, cache file

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Session Log file and Session Detail file

Answer Question  Select Best Answer

sravangopisetty

• Oct 10th, 2006

Ading to the point it also increase the no of rows in target.Example if the condition is given as sal

pushpa

• Oct 3rd, 2006

An active transformation can change the number of rows that pass through it.In Router you have the default group .If you want we can drop all rows in the default group, by not connecting it ...

Answer Question  Select Best Answer