Using a Table Without Importing It

In SQL Transform :

1)Create Output Columns that are required by seeing the table structure in the backend.

2)Do not import the table in the respective DataStore(The Schema i.e Connected with in which the table is available).

3)Select the appropriate DataStore in which the actual table is residing in the Backend but not in the datastore.

4)Write the appropriate SQL Query as per the columns created.

5)If you want, you can use the global variable which represent the respective schema name.

6) Do not click on the Update Schema.

7)Implement the Transformation Logic i.e required in the job.

8)Execute the job

BODI/BODS FAQS

1)Is it necessary to put Input Primarykey column in Table Comparison Transform 

It is mandatory to select primary key column

2)Parallel Processing

You can run transforms in parallel by entering a number in the Degree of Parallelism box on a data flow’s Properties window. The number is used to replicate transforms in the data flow which run as separate threads when the Job Server processes the data flow.

** Entering a number in the Degree of Parallelism box on a data flow’s Properties window.
** The number is used to replicate transforms in the data flow

3) Soure table Partitioning in Data Integrator , How will u load the data?


4) Performance tuning of a job

The following sections describe ways you can adjust Data Integrator
performance:

• Source-based performance options

• Using array fetch size
• Caching data
• Join ordering
• Minimizing extracted data

• Target-based performance options

• Loading method and rows per commit
• Staging tables to speed up auto-correct loads

• Job design performance options

• Improving throughput
• Maximizing the number of pushed-down operations
• Minimizing data type conversion
• Minimizing locale conversion
• Improving Informix repository performance


5) Parameters in Dataflow

LOCAL VARIABLES, GLOBAL VARIABLES, PARAMETERS.


Dataflow Level---Only Parameters.

Workflow Level---Parameters,Local Variables.

Job Level --- Local Variables, Global Variables.

You create local variables, parameters, and global variables using the Variables and Parameters window in the Designer.

You can set values for local or global variables in script objects. You can also
set global variable values using external job, execution, or schedule properties.


6) SCD Type 2 flow

1 way……….

In the DataFlow where the Intermediate Table and the Ultimate Target table are joined, we will be creating a port named DML_FLAG Which consists of {0/1/2} based on the following.

a) The SCD Columns that are retrieved from the Intermediate table & Ultimate Target table are compared over here.
b) If they are not matching we will assign with 2.
If they are matching we will assign with 1.
If the Surrogate Key of the Ultimate Target table is NULL then we will assign with 0.

So For DML_FLAG having value “2” we will have two dataflows one for insert and one for updating the target table.

Other way……….

SRC----TABLECOMPARISON----HISTORY PRESERVING----KEYGENERATION---TARGET.

Table Comparison-----Primary Key Columns,,,,,Compare columns(SCD Columns)
History Preserving----- Compare columns(SCD Columns)


7) Audit Strategy Implementation in the project



8) Different logs available in the Data Integrator

3 Data Integrator logs :

• Examining trace logs
• Examining statistics logs
• Examining error logs

**Use the trace logs to determine where an execution failed, whether the execution steps occur in the order you expect, and which parts of the execution are the most time consuming.

**The statistics log (also known as the monitor log) quantifies the activities of the components of the job. It lists the time spent in a given component of a job and the number of data rows that streamed through the component.

**Data Integrator produces an error log for every job execution. Use the error logs to determine how an execution failed. If the execution completed without error, the error log is blank.


9) Different Types of Embedded dataflows? Are they reusable.


An embedded data flow is a data flow that is called from inside another data flow.

There are four types of embedded data flows:

One input ---------Add an embedded data flow at the end of a data flow

One input and one output---------- Add an embedded data flow in the middle of a data flow.

One output --------Add an embedded data flow at the beginning of a data flow

No input or output---------- Replicate an existing data flow.

Yes. They are reusable.


10) Passing the parameters of one dataflow to other dataflows.

11) Bulk Loading

12)In how many ways Can we execute a job in BODI ? 

3 ways :

a)Manually
b)Thru Scheduling in WEB ADMIN.
c) Export Execution Command which is used to export the job into a batch file which is again executable.


12)What are the different types of Caches in LOOKUP? 

NO_CACHE — Does not cache any values.

• PRE_LOAD_CACHE — Preloads the result column and compare column
into memory (it loads the values before executing the lookup).
Use this option if the table can fit in memory.

• DEMAND_LOAD_CACHE — Loads the result column and compare
column into memory as the function executes.
Use this option when looking up highly repetitive values that are a small
subset of the data and when missing values are unlikely.


13)What is the significance of USE INPUT KEYS in Target table Options ? 

By setting this Data Integrator will use the primary keys of the source table in order to update the data in the target table.

14)Tell about QUERY TRANSFORM

Retrieves a data set that satisfies conditions that you specify. A query transform is similar to a SQL SELECT statement.
Select-----Distinct Rows
Outer Join -----Outer Source----Inner Source
Where………..You can put any kind of codition like lookup()/any built-in function which returns a single value.
By using Propose Joins DI automatically joins the columns that are having the same name and data type.
Group By ……Drag the columns that r needed to group.
Order By……..Drag the columns you want.

Can Use SQL().
Can use LookUp,LookUpEXT(),LookupSeq() or Built-In functions.
Can use relational operators in the conditions.
Can use Global variables.
Can use Custom Functions.

15)Implementation of INCREMENTAL LOADING 

Using the Last_Load_Timestamp of the target table.

If the source table's timestamp is > than the Maximum Last_Load_Timestamp

-----DIABETES DIET ---- 60 : 20 : 20 --- Carbs : Fats : Proteins -----

Diabetes diet for Indians should have the ratio of 60:20:20 for carbs, fats and proteins.
"Per day calorie intake should be between 1,500-1,800 calories with a proportion of 60:20:20 between carbohydrates, fats and proteins, respectively."
Should "have at least two seasonal fruits and three vegetables in a diet plan."

•  Drink tomato juice with salt and pepper every morning on an empty stomach.
•  Intake of 6 almonds (soaked overnight) is also helpful in keeping a check on diabetes.
•  Whole grains, oats, channa atta, millets and other high fibre foods should be included in the meals. 
• Milk is the right combination of carbohydrates and proteins and helps control blood sugar levels. Two servings of milk in a daily diet is a good option.
• High fibre vegetables such as peas, beans, broccoli and spinach /leafy vegetables should be included in one's diet. 
• Pulses are important in the diet as their effect on blood glucose is less than that of most other carbohydrate containing foods. 
• Good fats such as Omega-3 and monounsaturated fats (MUFA) should be consumed as they are good for the body.
• Natural sources for these are canola oil, flax seed oil, fatty fish and nuts. These are also low in cholesterol and are trans fat free.
• Fruits high in fibre such as papaya, apple, orange, pear and guava should be consumed. Mangoes, bananas, and grapes contain high sugar; therefore these fruits should be consumed lesser than the others.
• Small frequent meals: A large meal gives rise to higher blood sugar in one's body, therefore it is essential to take small frequent meals to prevent both higher and very low blood sugar values and keep them constant. Small in between snacks can be dhokla, fruit, high fibre cookies, butter milk, yogurt, upma/poha with vegetables etc.                                                                                                                          A person with diabetes should follow a diet which is low in carbohydrates, high in fibre and contains adequate amounts of proteins, vitamins and minerals; and avoid fatty foods and sweets. He/she should also take frequent small meals (5 meals pattern).

•  In non-vegetarian diet, seafood and chicken can be taken rather than red meat as red meat contains higher amount of saturated fats. Also, patients with high cholesterol should avoid egg yolk and red meat.

TABLETS

Saridon

Contains 135 mg of propyphenazone, 260 mg of paracetamol and 55 mg of caffeine

--Mild to severe headaches
--Toothache,
--Rheumatic pain,
--Fever associated with colds and flu.

Ibuprofen

• For  fever (including postimmunisation fever), mild-to-moderate pain (including pain relief after surgery), painful menstruation, osteoarthritis, dental pain, headaches and pain from kidney stones.
• Relieve pain and REDUCE SWELLING by inhibiting the body's INFLAMMATORY response

Cetirizine 

• For the relief of symptoms of hay fever (seasonal allergic rhinitis) and allergies such as dust or pet allergies (perennial allergic rhinitis), such as sneezing, itchy, runny and blocked nose, red and watery eyes.
• For the relief of swelling, redness and itchiness of the skin (symptoms of chronic idiopathic urticaria, which is also known as chronic nettle rash).

Lowering your Blood Pressure

1. Cut the salt: 
--No more than 2,000 mg of sodium or five grams of salt — the equivalent of one tea spoon — per day.
--Common Source of Excessive salt-- Processed and packaged foods, fast foods, and canned foods

2. Eat potassium: 

This mineral helps lower blood pressure.
 The recommended daily intake for adults is 3,510 mg.
 Potassium-rich foods include: beans and peas (approximately 1,300 mg of potassium per 100 g),
 nuts (approximately 600 mg/100 g),
 vegetables such as spinach, cabbage
 and fruits such as bananas, papayas and dates (approximately 300 mg/100 g).

3. Modify your diet: 
Eat at least five servings of fruits and vegetables for fibre and reduce processed foods in your diet.
Avoid salty food like sauces, pickles, chips etc. Fruits and vegetables are low in sodium and high in potassium which helps in lowering blood pressure.
Reduce fatty and fried food, especially saturated fats/transfats and replace them with polyunsaturated fats.

4. Check your weight: 
Blood pressure tends to increase as weight does. E
Fortunately, it's also true that BP tends to drop as weight does.
For optimum health, an adult should maintain a Body Mass Index (BMI)

5. Exercise: 
Getting enough sleep, deep breathing, meditation, yoga, and exercising for at least 30 minutes daily can help reduce stress.
Examples of moderate activities are brisk walking, cycling, gardening and housework.

6. Limit alcohol: 
Not only does too much alcohol raise blood pressure, repeated excess drinking can lead to long-term BP increases.
It is important to limit your alcohol intake.

Importance Of IRON in BLOOD

• Your "iron level" is checked before each blood donation to determine if it is safe for you to give blood.
•  Iron is not made in the body and must be absorbed from what you eat.
•  The adult minimum daily requirement of iron is 1.8 mg.
•  Foods high in vitamin C also are recommended because vitamin C helps your body absorb iron. 
• Breastfeeding increases iron requirements by about 0.5 to 1 mg a day.

Meat and Poultry:

• Lamb
• Chicken
• Turkey
• Liver (except fish liver)

Seafood

• Fish
• Mussels
• Shellfish

Vegetables

• Greens, all kinds
• Broccoli
• Sweet Peas
• Brussel Sprouts
• Bean Sprouts
• Tomatoes
• Lima Beans
• Potatoes
• Green Beans
• Corn
• Cabbage

Others

• Jaggery(Bellam in telugu)
• Kismiss
• Dates

Impact of Blood Pressure Ranges

• 90 over 60 (90/60) or less: You may have Low blood pressure. More on low blood pressure.

• More than 90 over 60 (90/60) and less than 120 over 80 (120/80): Your blood pressure reading is Ideal and healthy. Follow a healthy lifestyle to keep it at this level.

• More than 120 over 80 and less than 140 over 90 (120/80-140/90): You have a Normal blood pressure reading but it is a little higher than it should be, and you should try to lower it. Make healthy changes to your lifestyle.

• 140 over 90 (140/90) or higher (over a number of weeks): You may have High blood pressure (hypertension). Change your lifestyle - see your doctor or nurse and take any medicines they may give you. More on high blood pressure

Age 20+	Target Blood Sugar Levels for Diabetes
Fasting	< 100
Before Meal	70-130
After Meal(1-2 hrs)	< 180
Before Exercise	100 (if taking Insulin)
Bedtime	100-140