Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
HCL,
8177if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
2156What exactly mentioned in High level design document.can somebody explain me sequentialy.
IBM,
1 6589if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
IBM,
2 5719How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
IBM,
1 3446can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
IBM,
2 6722how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
1 4317Post New Informatica Questions
What is parallel processing in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Is it possible to revert a global repository to local one and why?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What all are steps in up gradation of Informatica server?
What is fact table? Explain the different kinds of facts.
Under what condition selecting sorted input in aggregator may fail the session?
How to join three sources using joiner? Explain though mapping flow.
How to convert multiple rows to single row (multiple columns) in informatica
How many input parameters can exist in an unconnected lookup?
wat are deployement groups in informatica, how it will be used for developers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the function of aggregator transformation?
