Shashikumar

• Jun 21st, 2007

Data Cleansing Tool: TriliumProfile tool: Informatica Profiler

Answer Question  Select Best Answer

yuva010

• Jun 20th, 2007

There is no as such best way, but you have to incorporate following steps -1. Change the name in Mapping Designer2. Refresh mapping?with right click on?session3. Reset the target connections.4. Save.

Answer Question  Select Best Answer

Pradeep Behera

• Jun 20th, 2007

Materialized view stores the result set of?a query, but normal view does not store the same. We can refresh the Materialised View when any changes are made in the master table. Normal view is only ...

rma

• Dec 12th, 2006

View doesn't occupy any storage space in table space, but meterilized view will occupy space

Answer Question  Select Best Answer

Prasad P

• Jun 11th, 2007

You can join that table which you wanted to use in lookup in the source qualifier using SQL override to avoid using lookup transformation

muzamil

• Aug 2nd, 2006

 You can use joiner in place of lookup

Answer Question  Select Best Answer

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

Rangini,Incremental Aggregations, I think informatica provides this feature to load the sessions which are abruptly termination in middle of the load, am I right? also I would like to know how you can...

Rangini vignesh

• Aug 30th, 2006

The above answer is slightly correct.The incremental loading is done in 3 ways by using Transformations.1.Aggregate Transformation,2.Dynamic Lookup Transformation,3.Update Strategy Transformation,In t...

Answer Question  Select Best Answer

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

two ways.1. go to navigation panel, under the mapping expand the Transformations folder, will list all the transformation including lookups... 2. but if you want to lookup and browse through only look...

SRIRAM N

• May 17th, 2007

You can have look on all the look-ups that are avialable in a mapping through,???????????? Workflow--> session --> EDIT (and look in MAPPINGS tab)

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 5th, 2007

The default user groups:      1) Administrators      2) Public

Answer Question  Select Best Answer

Navin

• Jun 2nd, 2007

With 32-bit the max memory?you can have for a session is 2^32With 64-bit?the max memory you can have 2^64 - more memory means?faster execution of sessionNavin

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 30th, 2007

Hi,You can do it through file list. You have create a file containing path of all file. And u have to give that file name in session properties and select indirect.Thanks,imran

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi Manish Bhai, Cofiguration management means when u r installing the informatica that time u have some options to set according to ur choice. Like u want to use unicode and ascii mode, there r some other options. I have only this much idea about it. If i am right then tell me.ThanksImran Nabi

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6)...

Answer Question  Select Best Answer

ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?

latha

• May 29th, 2007

Use the Normalizer transformation to take the Mainframe sources(COBOL)

vishnukirank

 Profile Answers by vishnukirank Questions by vishnukirank

• May 26th, 2007

Use Informatica Power Connect to connect to external systems like Mainframes and import the source tables.

Answer Question  Select Best Answer

Which transformation you can use to get n+1 records in Target database from N records source

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Normalizer bcoz it increases the no of rows. I hope it will help u.Thanks,imran

Answer Question  Select Best Answer

Abhishek Pathak

• May 25th, 2007

Main difference between using a object from shared folder is that it will be used as Shortcut to shared folder so in future if any changes happened to that object so by changing its definition in...

Answer Question  Select Best Answer

naga

• May 24th, 2007

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example?country, state, city, area in this surrogate key is with 'AREA'

shaik

• Jun 27th, 2006

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table.

Answer Question  Select Best Answer

Yes.Because reusable tranformation is not contained with any maplet or maping.

Prasad

• May 22nd, 2007

Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.

mahesh4346

 Profile Answers by mahesh4346 Questions by mahesh4346

• Feb 2nd, 2007

But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...

Answer Question  Select Best Answer

g.nagaprasad

 Profile Answers by g.nagaprasad Questions by g.nagaprasad

• May 22nd, 2007

In lookup transformation there is a default clause ORDER BY...  but in case of Source Qualifier we have to give manually.

Answer Question  Select Best Answer

SRIRAM N

• May 17th, 2007

You can compare two mappings 1) with in one folder 2) two mappings in two differnt foldersMapping Designer --> Open folders--> MAPPING tab --> Compare then select two mappings to compare.Thats it !? Thanks it is working.

Answer Question  Select Best Answer

J.David Sukeerthi Kumar

• May 17th, 2007

There is on option called 'COMMIT INTERVAL', (By default its value is 10000 records)That means for every 10000 records? loaded ,the informatica server will issue an COMMIT command.If we specify 'SOUR...

Answer Question  Select Best Answer

ramgan_tryst

 Profile Answers by ramgan_tryst Questions by ramgan_tryst

• May 15th, 2007

Check-In and Check-Out refers to Versioning your Mapping. It is like maintaining the changes you have made. It is like using VSS or CVS. When you right-click you mapping, you have a option called Versioning if you have got that facility enabled.

Answer Question  Select Best Answer