Total Answers Posted # 67
Total Answers Posted for My Questions # 54
Total Views for My Questions # 161100
Users Marked my Answers as Correct # 415
Users Marked my Answers as Wrong # 278
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
6 Informatica 15353How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
5 Informatica 8500Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
2 Informatica 10155Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
CTS,
2 Informatica 8114LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
6 Informatica 21007I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
4 Informatica 9315
What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally?
Answer
You need Cure the Data using Default values,Null
updates,,,like many things r there,,
In Inf trans Avoid the nulls,Correct DataType with
Length,Unique data,,,,like,,many ways u can cure the data.
| Is This Answer Correct ? | 0 Yes | 3 No |
Question { 5532 }
can we have an unconnected lkp to lookup a DB2 record
against a Teradata record?
Answer
We can use like Like,(Diff Databases)
| Is This Answer Correct ? | 1 Yes | 0 No |
Question { 6854 }
How will u pas the data with out debugger?
Answer
The Debugger will show the data flow from Sql trans TO
Target only.
How source rows are transfor ONE Trans to Another Trans up
Target we can watch phisically also,
and watch the Rejected rows also.
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Question { 3467 }
What is a configuration management?
Answer
from Repository from Clint application.
Power Center Intigration service :Run the Power Center
Sessions,Workflows and fetch the Metada from Power center
Repository.
Metadata Menager service :Runs the metadata manager
application in the power center domain.
Reporting Service :Runs the data analyser application in
the power center domain.You creat a reporting service to
run reports on power center or Matadata manager Repository.
Not only these ,,,,
All Configaration related things will come under
configuration management.
If there is any Corrections Please let me know.
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
can anyone explain me about sales project in informatica?
Answer
Jsut say :in Total EDW my modulele is Customer data
maintaince,We follow up his History to Present data.
We are using 4 Facts,7 dimemenstions in Star schema.
Try develope this way of Explanation,,,,All the best,,,
| Is This Answer Correct ? | 8 Yes | 12 No |
Question { 9214 }
Which is costliest transformation? costly means occupying
more memory?
Answer
its going to maintain existing data also in cach memory
| Is This Answer Correct ? | 7 Yes | 0 No |
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
Answer
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
I am not confident check itonce let me know,,
Thanks
Srinu
| Is This Answer Correct ? | 5 Yes | 17 No |
Question { 26589 }
Why Fload doesn’t support multiset table?
Answer
Mean Concurrently,Bulk Insert.
Internally TeraData server will Create
Bulk insert DML statament
(Like: insert into Table1 as sel * from Table2
with data)
For Fast Performence it will not support the
duplicate values,Refential Intigrity,,,,
If u know the Better answer compare to this let me Know,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 0 Yes | 15 No |
Question { 14998 }
Why AMP & PE are called Vprocs?
Answer
From PE to AMP (This is the network root via MSP(messege
passing layer),The processing data will store in Disks
(These are Physical disks),Each Amp have too many P.disks,
to migrate these P.disks The Bynet Network maintains
Virtual disks.Thses V.disks will responsible for data
migration.
That y we called this process is Virtual Process(VPROCS).
I think it will help u,,,,,
| Is This Answer Correct ? | 0 Yes | 15 No |
Explain about Skew Factor?
Answer
will hadle the duplicate rows up to limitations,Once its
cross the no of Rows it will effect on Performence.The Dba
people will the SKEW tables.
I think this Answer helps u
| Is This Answer Correct ? | 10 Yes | 29 No |
Question { 3801 }
sir presently i am persuing my m.tech
recently i got job in tcs as fresher presently iam doing my
9 months project related to informatica can any one guide
me how to create fact tables what type of schemas must be
used and so on if so give ur mail ids so that i can contct
through it
Answer
(DBA people or senior architects) with PK-FK relation.
Mstly people will create PK-FK relation in facts After
loading the Data in Table).
Schemas : Mostly STAR Schema.
It will be useful for u ,,,,,,,,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Question { 21828 }
How a Referential integrity is handled in Teradata?
Answer
| Is This Answer Correct ? | 7 Yes | 17 No |
