Interested to Buy Any Domain ? << Click Here >> for more details...
-
Teradata (490) - Business Objects (875)
- Cognos (1143)
- Informatica (2428)
- Crystal Enterprise Suite (30)
- Actuate (46)
- Ab Initio (442)
- Data Stage (917)
- SAS (1049)
- Micro Strategy (282)
- ETL (315)
- OBIEE (92)
- IBM Cognos TM1 (55)
- Amazon Redshift (62)
- Data Warehouse General (749)
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
TCS,
2 7268suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
2134how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
2172in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
TCS,
2042write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
TCS,
2 6131write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
HP,
2 6154write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
4 9842write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
5 11635how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
CTC,
4 26110SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
TCS,
1 6626What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 6358write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
2 6763write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
1 3488wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
3 7607
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the purpose of cluster analysis in data warehousing?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is SAS informats?
Explain connectivity between datastage with datasources?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What are the functions involved in shared information architecture?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is the difference between cubes and package in cognos
if 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.
Mention the category in which sas informats are placed?
What is level prompt?
Explain rw document?
-----------------What is Determination Model?
List the logical and conditional operators that are used with teradata along with their meanings?
